@echo off
call echo +check-------------------------------------+
call python main.py --check


call echo +s1----------------------------------------+
call python main.py --s1


call echo +audio-------------------------------------+
call python main.py --audio


call echo +schema------------------------------------+
call python main.py --schema


pushd schema
call mysql -uroot -pwell_talent well < ddl/high_school.xlsx.ddl.sql
call mysql -uroot -pwell_talent well < dml/high_school.data.xlsx.dml.sql
call mysql -uroot -pwell_talent well < ddl/phonics.xlsx.ddl.sql
call mysql -uroot -pwell_talent well < dml/phonics.data.xlsx.dml.sql
call mysql -uroot -pwell_talent well < ddl/practical_1.xlsx.ddl.sql
call mysql -uroot -pwell_talent well < dml/practical_1.data.xlsx.dml.sql
call mysql -uroot -pwell_talent well < ddl/practical_2.xlsx.ddl.sql
call mysql -uroot -pwell_talent well < dml/practical_2.data.xlsx.dml.sql
call mysql -uroot -pwell_talent well < ddl/practical_3.xlsx.ddl.sql
call mysql -uroot -pwell_talent well < dml/practical_3.data.xlsx.dml.sql
call mysql -uroot -pwell_talent well < ddl/practical_4.xlsx.ddl.sql
call mysql -uroot -pwell_talent well < dml/practical_4.data.xlsx.dml.sql
call mysql -uroot -pwell_talent well < ddl/tem4.xlsx.ddl.sql
call mysql -uroot -pwell_talent well < dml/tem4.data.xlsx.dml.sql
call mysql -uroot -pwell_talent well < ddl/account.xlsx.ddl.sql
popd

pause
